﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

#pragma warning disable CA1814 // Prefer jagged arrays over multidimensional

namespace EFCore.Migrations
{
    /// <inheritdoc />
    public partial class init : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Bonus",
                columns: table => new
                {
                    BonId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    BonusItem = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    BonusWorth = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    BonusDegree = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckStatus = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Bonus", x => x.BonId);
                });

            migrationBuilder.CreateTable(
                name: "CFFK",
                columns: table => new
                {
                    FfkId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    FirstKindSalaryId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    FirstKindSaleId = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CFFK", x => x.FfkId);
                });

            migrationBuilder.CreateTable(
                name: "CFSK",
                columns: table => new
                {
                    FskId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondSalaryId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    SecondSaleId = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CFSK", x => x.FskId);
                });

            migrationBuilder.CreateTable(
                name: "CFTK",
                columns: table => new
                {
                    FtkId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdSaleId = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ThirdKindIf = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CFTK", x => x.FtkId);
                });

            migrationBuilder.CreateTable(
                name: "CM",
                columns: table => new
                {
                    MakId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TestAmount = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CM", x => x.MakId);
                });

            migrationBuilder.CreateTable(
                name: "CMK",
                columns: table => new
                {
                    MfkId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CMK", x => x.MfkId);
                });

            migrationBuilder.CreateTable(
                name: "CPC",
                columns: table => new
                {
                    PbcId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    AttributeKind = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    AttributeName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CPC", x => x.PbcId);
                });

            migrationBuilder.CreateTable(
                name: "CQFK",
                columns: table => new
                {
                    QfkId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CQFK", x => x.QfkId);
                });

            migrationBuilder.CreateTable(
                name: "CQSK",
                columns: table => new
                {
                    QskId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CQSK", x => x.QskId);
                });

            migrationBuilder.CreateTable(
                name: "EA",
                columns: table => new
                {
                    AnsId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    AnswerNumber = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ExamNumber = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ResumeId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    InterviewIid = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(6)", maxLength: 6, nullable: true),
                    HumanIdcard = table.Column<string>(type: "nvarchar(18)", maxLength: 18, nullable: true),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<int>(type: "int", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TestTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    UseTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    TotalPoint = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EA", x => x.AnsId);
                });

            migrationBuilder.CreateTable(
                name: "EAD",
                columns: table => new
                {
                    AndId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    AnswerNumber = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SubjectId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    Answer = table.Column<string>(type: "nvarchar(300)", maxLength: 300, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EAD", x => x.AndId);
                });

            migrationBuilder.CreateTable(
                name: "EE",
                columns: table => new
                {
                    ExaId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    ExamNumber = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    LimiteTime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EE", x => x.ExaId);
                });

            migrationBuilder.CreateTable(
                name: "EED",
                columns: table => new
                {
                    ExdId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    ExamNumber = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    QuestionAmount = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EED", x => x.ExdId);
                });

            migrationBuilder.CreateTable(
                name: "EI",
                columns: table => new
                {
                    EinId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    InterviewAmount = table.Column<int>(type: "int", nullable: true),
                    HumanMajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanMajorKindName = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanMajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HunmaMajorName = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    ImageDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    NativeLanguageDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    ForeignLanguageDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    ResponseSpeedDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    EQDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    IQDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    MultiQualityDegree = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegisteTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ResumeId = table.Column<int>(type: "int", nullable: true),
                    Result = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    InterviewComment = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    CheckComment = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    InterviewStatus = table.Column<int>(type: "int", nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EI", x => x.EinId);
                });

            migrationBuilder.CreateTable(
                name: "EMR",
                columns: table => new
                {
                    MreId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanAmount = table.Column<int>(type: "int", nullable: true),
                    EngageType = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Deadline = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Changer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    MajorDescribe = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    EngageRequired = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_EMR", x => x.MreId);
                });

            migrationBuilder.CreateTable(
                name: "ER",
                columns: table => new
                {
                    ResId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    EngageType = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanAddress = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanPostcode = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
                    HumanMajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanMajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HunmaMajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanTelephone = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanHomephone = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMobilephone = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanEmail = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanHobby = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanSpeciality = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanSex = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanReligion = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanParty = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanNationality = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanRace = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanBirthday = table.Column<DateTime>(type: "datetime2", nullable: true),
                    HumanAge = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedDegree = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanEducatedYears = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedMajor = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanCollege = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanIdcard = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanBirthplace = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    DemandSalaryStandard = table.Column<double>(type: "float", nullable: true),
                    HumanHistoryRecords = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    Recomandation = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanPicture = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    AttachmentName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    InterviewStatus = table.Column<int>(type: "int", nullable: true),
                    TotalPoints = table.Column<double>(type: "float", nullable: true),
                    TestAmount = table.Column<int>(type: "int", nullable: true),
                    TestChecker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TestCheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    PassRegister = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    PassRegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    PassChecker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    PassCheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    PassCheckStatus = table.Column<int>(type: "int", nullable: true),
                    PassCheckComment = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    PassPassComment = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ER", x => x.ResId);
                });

            migrationBuilder.CreateTable(
                name: "ES",
                columns: table => new
                {
                    SubId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Derivation = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Content = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    KeyA = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    KeyB = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    KeyC = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    KeyD = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    KeyE = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    CorrectKey = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Changer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ES", x => x.SubId);
                });

            migrationBuilder.CreateTable(
                name: "GroupMenu",
                columns: table => new
                {
                    GroupID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    GroupName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_GroupMenu", x => x.GroupID);
                });

            migrationBuilder.CreateTable(
                name: "HF",
                columns: table => new
                {
                    HufId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HumanId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanAddress = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanPostcode = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
                    HumanProDesignation = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanMajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HunmaMajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanTelephone = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    HumanMobilephone = table.Column<string>(type: "nvarchar(11)", maxLength: 11, nullable: true),
                    HumanBank = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanAccount = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanQQ = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                    HumanEmail = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanHobby = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSpeciality = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSex = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanReligion = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanParty = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanNationality = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanRace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanBirthday = table.Column<DateTime>(type: "datetime2", nullable: true),
                    HumanBirthplace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanAge = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedDegree = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanEducatedYears = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedMajor = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSocietySecurityId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanIdCard = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    SalaryStandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    SalaryStandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SalarySum = table.Column<double>(type: "float", nullable: true),
                    DemandSalaraySum = table.Column<double>(type: "float", nullable: true),
                    PaidSalarySum = table.Column<double>(type: "float", nullable: true),
                    MajorChangeAmount = table.Column<int>(type: "int", nullable: true),
                    BonusAmount = table.Column<int>(type: "int", nullable: true),
                    TrainingAmount = table.Column<int>(type: "int", nullable: true),
                    FileChangAmount = table.Column<int>(type: "int", nullable: false),
                    HumanHistroyRecords = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HumanFamilyMembership = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HumanPicture = table.Column<string>(type: "nvarchar(225)", maxLength: 225, nullable: true),
                    AttachmentName = table.Column<string>(type: "nvarchar(225)", maxLength: 225, nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Changer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    LastlyChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    DeleteTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    RecoveryTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    HumanFileStatus = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_HF", x => x.HufId);
                });

            migrationBuilder.CreateTable(
                name: "HFD",
                columns: table => new
                {
                    HfdId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    HumanId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: false),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanAddress = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    HumanPostcode = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
                    HumanProDesignation = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanMajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanMajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HunmaMajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanTelephone = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                    HumanMobilephone = table.Column<string>(type: "nvarchar(11)", maxLength: 11, nullable: true),
                    HumanBank = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanAccount = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanQQ = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                    HumanEmail = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanHobby = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSpeciality = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSex = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanReligion = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanParty = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanNationality = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanRace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanBirthday = table.Column<DateTime>(type: "datetime2", nullable: true),
                    HumanBirthplace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    HumanAge = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedDegree = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanEducatedYears = table.Column<int>(type: "int", nullable: true),
                    HumanEducatedMajor = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanSocietySecurityId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanIdCard = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    SalaryStandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    SalaryStandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SalarySum = table.Column<double>(type: "float", nullable: true),
                    DemandSalaraySum = table.Column<double>(type: "float", nullable: true),
                    PaidSalarySum = table.Column<double>(type: "float", nullable: true),
                    MajorChangeAmount = table.Column<int>(type: "int", nullable: true),
                    BonusAmount = table.Column<int>(type: "int", nullable: true),
                    TrainingAmount = table.Column<int>(type: "int", nullable: true),
                    FileChangAmount = table.Column<int>(type: "int", nullable: false),
                    HumanHistroyRecords = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HumanFamilyMembership = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    HumanPicture = table.Column<string>(type: "nvarchar(225)", maxLength: 225, nullable: true),
                    AttachmentName = table.Column<string>(type: "nvarchar(225)", maxLength: 225, nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Changer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    LastlyChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    DeleteTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    RecoveryTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    HumanFileStatus = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_HFD", x => x.HfdId);
                });

            migrationBuilder.CreateTable(
                name: "Jurisdiction",
                columns: table => new
                {
                    JuriID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    JurName = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    GroupID = table.Column<int>(type: "int", nullable: false),
                    JurAddress = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Jurisdiction", x => x.JuriID);
                });

            migrationBuilder.CreateTable(
                name: "MC",
                columns: table => new
                {
                    MchId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewFirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    NewFirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewSecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    NewSecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    NewThirdkindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewMajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    NewMajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewMajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    NewMajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SalaryStandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    SalaryStandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SalarySum = table.Column<double>(type: "float", nullable: true),
                    NewSalaryStandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    NewSalaryStandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    NewSalarySum = table.Column<double>(type: "float", nullable: true),
                    ChangeReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CheckReason = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MC", x => x.MchId);
                });

            migrationBuilder.CreateTable(
                name: "Roles",
                columns: table => new
                {
                    RolesID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    RolesName = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    RolesInstruction = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    RolesIf = table.Column<bool>(type: "bit", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Roles", x => x.RolesID);
                });

            migrationBuilder.CreateTable(
                name: "RolesJurisdiction",
                columns: table => new
                {
                    RolesJID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    RolesID = table.Column<int>(type: "int", nullable: false),
                    JuriID = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_RolesJurisdiction", x => x.RolesJID);
                });

            migrationBuilder.CreateTable(
                name: "SG",
                columns: table => new
                {
                    SgrId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    SalaryGrantId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    SalaryStandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    FirstKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    FirstKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    SecondKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    SecondKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ThirdKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    ThirdKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanAmount = table.Column<int>(type: "int", nullable: true),
                    SalaryStandardSum = table.Column<double>(type: "float", nullable: true),
                    SalaryPaidSum = table.Column<double>(type: "float", nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckStatus = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SG", x => x.SgrId);
                });

            migrationBuilder.CreateTable(
                name: "SGD",
                columns: table => new
                {
                    GrdId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    SalaryGrantId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    BounsSum = table.Column<double>(type: "float", nullable: true),
                    SaleSum = table.Column<double>(type: "float", nullable: true),
                    DeductSum = table.Column<double>(type: "float", nullable: true),
                    SalaryStandardSum = table.Column<double>(type: "float", nullable: true),
                    SalaryPaidSum = table.Column<double>(type: "float", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SGD", x => x.GrdId);
                });

            migrationBuilder.CreateTable(
                name: "SS",
                columns: table => new
                {
                    SsdId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    StandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    StandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Designer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Register = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Changer = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ChangeTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    SalarySum = table.Column<double>(type: "float", nullable: true),
                    CheckStatus = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ChangeStatus = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CheckComment = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SS", x => x.SsdId);
                });

            migrationBuilder.CreateTable(
                name: "SSD",
                columns: table => new
                {
                    SdtId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    StandardId = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                    StandardName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    ItemId = table.Column<int>(type: "int", nullable: true),
                    ItemName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    Salary = table.Column<double>(type: "float", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SSD", x => x.SdtId);
                });

            migrationBuilder.CreateTable(
                name: "Training",
                columns: table => new
                {
                    TrId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    MajorKindId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorKindName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    MajorId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    MajorName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    HumanId = table.Column<string>(type: "nvarchar(2)", maxLength: 2, nullable: true),
                    HumanName = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TrainingItem = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TrainingTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    TrainingHour = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    TrainingDegree = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Register = table.Column<int>(type: "int", nullable: true),
                    Checker = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                    RegistTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CheckTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    Checkstatus = table.Column<int>(type: "int", nullable: true),
                    Remark = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Training", x => x.TrId);
                });

            migrationBuilder.CreateTable(
                name: "User",
                columns: table => new
                {
                    UId = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    UName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false),
                    UTrueName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false),
                    UPassWord = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_User", x => x.UId);
                });

            migrationBuilder.CreateTable(
                name: "UserRoles",
                columns: table => new
                {
                    UserRolesID = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    UserID = table.Column<int>(type: "int", nullable: false),
                    RolesID = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_UserRoles", x => x.UserRolesID);
                });

            migrationBuilder.InsertData(
                table: "CFFK",
                columns: new[] { "FfkId", "FirstKindId", "FirstKindName", "FirstKindSalaryId", "FirstKindSaleId" },
                values: new object[] { 1, "01", "集团", "1", "1" });

            migrationBuilder.InsertData(
                table: "CFSK",
                columns: new[] { "FskId", "FirstKindId", "FirstKindName", "SecondKindId", "SecondKindName", "SecondSalaryId", "SecondSaleId" },
                values: new object[,]
                {
                    { 1, "01", "集团", "01", "软件公司", "1", "1" },
                    { 2, "01", "集团", "02", "生物科技有限公司", "1", "1" }
                });

            migrationBuilder.InsertData(
                table: "CFTK",
                columns: new[] { "FtkId", "FirstKindId", "FirstKindName", "SecondKindId", "SecondKindName", "ThirdKindId", "ThirdKindIf", "ThirdKindName", "ThirdSaleId" },
                values: new object[,]
                {
                    { 1, "01", "集团", "01", "软件公司", "01", "否", "外包组", "01" },
                    { 2, "01", "集团", "02", "生物科技有限公司", "01", "是", "药店", "01" }
                });

            migrationBuilder.InsertData(
                table: "CM",
                columns: new[] { "MakId", "MajorId", "MajorKindId", "MajorKindName", "MajorName", "TestAmount" },
                values: new object[,]
                {
                    { 1, "01", "01", "销售", "区域经理", 0 },
                    { 2, "02", "01", "销售", "总经理", 0 },
                    { 3, "01", "02", "软件开发", "区域经理", 0 },
                    { 4, "02", "02", "软件开发", "程序员", 0 },
                    { 5, "01", "03", "人力资源", "人事经理", 0 },
                    { 6, "02", "03", "人力资源", "专员", 0 },
                    { 7, "01", "04", "生产部", "主任", 0 },
                    { 8, "02", "04", "生产部", "技术工人", 0 }
                });

            migrationBuilder.InsertData(
                table: "CMK",
                columns: new[] { "MfkId", "MajorKindId", "MajorKindName" },
                values: new object[,]
                {
                    { 1, "01", "销售" },
                    { 2, "02", "软件开发" },
                    { 3, "03", "人力资源" },
                    { 4, "04", "生产部" }
                });

            migrationBuilder.InsertData(
                table: "CPC",
                columns: new[] { "PbcId", "AttributeKind", "AttributeName" },
                values: new object[,]
                {
                    { 1, "国籍", "中国" },
                    { 2, "国籍", "美国" },
                    { 3, "民族", "汉族" },
                    { 4, "民族", "回族" },
                    { 5, "宗教信仰", "无" },
                    { 6, "宗教信仰", "佛教" },
                    { 7, "政治面貌", "党员" },
                    { 8, "政治面貌", "群众" },
                    { 9, "教育年限", "12" },
                    { 10, "教育年限", "16" },
                    { 11, "学历", "本科" },
                    { 12, "学历", "大专" },
                    { 13, "专业", "生物工程" },
                    { 14, "专业", "计算机" },
                    { 15, "特长", "数据库" },
                    { 16, "特长", "java" },
                    { 17, "爱好", "篮球" },
                    { 18, "爱好", "舞蹈" },
                    { 19, "培训项目", "英语" },
                    { 20, "培训项目", "管理" },
                    { 21, "培训成绩", "A" },
                    { 22, "培训成绩", "B" },
                    { 23, "奖励项目", "技术攻关" },
                    { 24, "奖励项目", "销售绩效" },
                    { 25, "奖励等级", "A" },
                    { 26, "奖励等级", "B" },
                    { 27, "职称", "工程师" },
                    { 28, "职称", "经理" },
                    { 29, "职称", "助理" },
                    { 30, "职称", "教授" },
                    { 31, "职称", "讲师" },
                    { 32, "职称", "技术支持" },
                    { 33, "薪酬设置", "出差补助" },
                    { 34, "薪酬设置", "交通补贴" },
                    { 35, "薪酬设置", "住房补贴" },
                    { 36, "薪酬设置", "基本工资" },
                    { 37, "薪酬设置", "年终奖" },
                    { 38, "薪酬设置", "误餐补助" }
                });

            migrationBuilder.InsertData(
                table: "User",
                columns: new[] { "UId", "UName", "UPassWord", "UTrueName" },
                values: new object[,]
                {
                    { 1, "admin", "123456", "管理员" },
                    { 2, "wan", "123456", "万岳军" }
                });
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Bonus");

            migrationBuilder.DropTable(
                name: "CFFK");

            migrationBuilder.DropTable(
                name: "CFSK");

            migrationBuilder.DropTable(
                name: "CFTK");

            migrationBuilder.DropTable(
                name: "CM");

            migrationBuilder.DropTable(
                name: "CMK");

            migrationBuilder.DropTable(
                name: "CPC");

            migrationBuilder.DropTable(
                name: "CQFK");

            migrationBuilder.DropTable(
                name: "CQSK");

            migrationBuilder.DropTable(
                name: "EA");

            migrationBuilder.DropTable(
                name: "EAD");

            migrationBuilder.DropTable(
                name: "EE");

            migrationBuilder.DropTable(
                name: "EED");

            migrationBuilder.DropTable(
                name: "EI");

            migrationBuilder.DropTable(
                name: "EMR");

            migrationBuilder.DropTable(
                name: "ER");

            migrationBuilder.DropTable(
                name: "ES");

            migrationBuilder.DropTable(
                name: "GroupMenu");

            migrationBuilder.DropTable(
                name: "HF");

            migrationBuilder.DropTable(
                name: "HFD");

            migrationBuilder.DropTable(
                name: "Jurisdiction");

            migrationBuilder.DropTable(
                name: "MC");

            migrationBuilder.DropTable(
                name: "Roles");

            migrationBuilder.DropTable(
                name: "RolesJurisdiction");

            migrationBuilder.DropTable(
                name: "SG");

            migrationBuilder.DropTable(
                name: "SGD");

            migrationBuilder.DropTable(
                name: "SS");

            migrationBuilder.DropTable(
                name: "SSD");

            migrationBuilder.DropTable(
                name: "Training");

            migrationBuilder.DropTable(
                name: "User");

            migrationBuilder.DropTable(
                name: "UserRoles");
        }
    }
}
